import numpy as np
import pandas as pd

df1 = pd.read_excel("NACA 2414/Re=60400/UIUC_CS_Re60400.xlsx", engine='openpyxl')
df2 = pd.read_excel("NACA 2414/Re=100800/UIUC_CS_Re100800.xlsx", engine='openpyxl')
df3 = pd.read_excel('NACA 2414/Re=201600/UIUC_CS_Re201600.xlsx', engine='openpyxl')
df4 = pd.read_excel("NACA 2414/Re=302700/UIUC_CS_Re302700.xlsx", engine='openpyxl')

x1 = np.array(df1.iloc[:, [3, 0]])
x2 = np.array(df2.iloc[:, [3, 0]])
x3 = np.array(df3.iloc[:, [3, 0]])
x4 = np.array(df4.iloc[:, [3, 0]])

y1 = np.array(df1.iloc[:, [4, 2]])
y2 = np.array(df2.iloc[:, [4, 2]])
y3 = np.array(df3.iloc[:, [4, 2]])
y4 = np.array(df4.iloc[:, [4, 2]])

inX1 = np.linspace(x1[0], x1[20], 100)
inX2 = np.linspace(x2[0], x2[20], 100)
inX3 = np.linspace(x3[0], x3[20], 100)
inX4 = np.linspace(x4[0], x4[20], 100)
inX = np.concatenate((inX1, inX2, inX3, inX4))

print(inX)
